Insiders Clustering - Exploratory Data Analysis

Dataset statistics

Number of variables	13
Number of observations	2959
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	289.1 KiB
Average record size in memory	100.0 B

Variable types

NUM	13

Reproduction

Analysis started	2021-05-24 18:02:18.320903
Analysis finished	2021-05-24 18:03:14.307562
Duration	55.99 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`total_quantity` is highly correlated with `gross_revenue`	High correlation
`gross_revenue` is highly correlated with `total_quantity`	High correlation
`returns` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_ticket` is highly correlated with `returns` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.35524577)	Skewed
`returns` is highly skewed (γ1 = 51.74099745)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.66349716)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`avg_ticket` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`returns` has 1481 (50.1%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	2959
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2307.841838458939
Minimum	0
Maximum	5685
Zeros	1
Zeros (%)	< 0.1%
Memory size	23.1 KiB

Quantile statistics

Minimum	0
5-th percentile	184.9
Q1	924.5
median	2110
Q3	3521.5
95-th percentile	5020.4
Maximum	5685
Range	5685
Interquartile range (IQR)	2597

Descriptive statistics

Standard deviation	1548.743202
Coefficient of variation (CV)	0.6710785707
Kurtosis	-1.007193055
Mean	2307.841838
Median Absolute Deviation (MAD)	1268
Skewness	0.3438146073
Sum	6828904
Variance	2398605.507

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4094	1	< 0.1%
4540	1	< 0.1%
4524	1	< 0.1%
1278	1	< 0.1%
3323	1	< 0.1%
1274	1	< 0.1%
3319	1	< 0.1%
3317	1	< 0.1%
1268	1	< 0.1%
3313	1	< 0.1%
Other values (2949)	2949	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
5685	1	< 0.1%
5675	1	< 0.1%
5669	1	< 0.1%
5648	1	< 0.1%
5644	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct count	2959
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15274.081446434606
Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	12347
5-th percentile	12623.7
Q1	13806.5
median	15227
Q3	16769
95-th percentile	17964.1
Maximum	18287
Range	5940
Interquartile range (IQR)	2962.5

Descriptive statistics

Standard deviation	1717.644411
Coefficient of variation (CV)	0.1124548417
Kurtosis	-1.205531349
Mean	15274.08145
Median Absolute Deviation (MAD)	1484
Skewness	0.02900451519
Sum	45196007
Variance	2950302.321

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
14335	1	< 0.1%
15679	1	< 0.1%
15689	1	< 0.1%
17736	1	< 0.1%
15687	1	< 0.1%
17734	1	< 0.1%
13636	1	< 0.1%
12722	1	< 0.1%
13634	1	< 0.1%
15681	1	< 0.1%
Other values (2949)	2949	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	2953
Unique (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2756.250922608989
Minimum	15.0
Maximum	279138.01999999984
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	15
5-th percentile	233.229
Q1	573.085
median	1091.39
Q3	2312.09
95-th percentile	7237.701
Maximum	279138.02
Range	279123.02
Interquartile range (IQR)	1739.005

Descriptive statistics

Standard deviation	10597.64586
Coefficient of variation (CV)	3.844949592
Kurtosis	352.8143682
Mean	2756.250923
Median Absolute Deviation (MAD)	674.75
Skewness	16.75139769
Sum	8155746.48
Variance	112310097.8

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
379.65	2	0.1%
731.9	2	0.1%
734.94	2	0.1%
745.06	2	0.1%
331	2	0.1%
533.33	2	0.1%
1842.14	1	< 0.1%
618.52	1	< 0.1%
899.63	1	< 0.1%
9430.52	1	< 0.1%
Other values (2943)	2943	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%

recency_days
Real number (ℝ_≥0)

ZEROS

Distinct count	272
Unique (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	64.1753970936127
Minimum	0.0
Maximum	373.0
Zeros	34
Zeros (%)	1.1%
Memory size	23.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.70318513
Coefficient of variation (CV)	1.21079399
Kurtosis	2.789481599
Mean	64.17539709
Median Absolute Deviation (MAD)	26
Skewness	1.800506206
Sum	189895
Variance	6037.784979

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.9%
2	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	65	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2210	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%

number_of_purchases
Real number (ℝ_≥0)

Distinct count	56
Unique (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.738763095640419
Minimum	1.0
Maximum	206.0
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.867384912
Coefficient of variation (CV)	1.545173544
Kurtosis	190.4643752
Mean	5.738763096
Median Absolute Deviation (MAD)	2
Skewness	10.75880319
Sum	16981
Variance	78.63051517

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	784	26.5%
3	499	16.9%
4	393	13.3%
5	237	8.0%
1	181	6.1%
6	173	5.8%
7	138	4.7%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	181	6.1%
2	784	26.5%
3	499	16.9%
4	393	13.3%
5	237	8.0%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%

total_quantity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	1668
Unique (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1613.1263940520446
Minimum	1.0
Maximum	196844.0
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	1
5-th percentile	103
Q1	298
median	642
Q3	1401.5
95-th percentile	4410.9
Maximum	196844
Range	196843
Interquartile range (IQR)	1103.5

Descriptive statistics

Standard deviation	5897.012223
Coefficient of variation (CV)	3.655641768
Kurtosis	464.5308241
Mean	1613.126394
Median Absolute Deviation (MAD)	422
Skewness	17.83100874
Sum	4773241
Variance	34774753.15

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
310	11	0.4%
150	9	0.3%
288	8	0.3%
88	8	0.3%
246	8	0.3%
84	8	0.3%
260	8	0.3%
493	7	0.2%
516	7	0.2%
272	7	0.2%
Other values (1658)	2878	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
12	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%

product_variety
Real number (ℝ_≥0)

Distinct count	341
Unique (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	79.53092260898953
Minimum	1.0
Maximum	1786.0
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	26
median	52
Q3	101
95-th percentile	234
Maximum	1786
Range	1785
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	96.93923869
Coefficient of variation (CV)	1.21888739
Kurtosis	82.3396579
Mean	79.53092261
Median Absolute Deviation (MAD)	33
Skewness	6.389759612
Sum	235332
Variance	9397.215997

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
24	44	1.5%
18	39	1.3%
37	39	1.3%
28	39	1.3%
26	37	1.3%
25	37	1.3%
14	36	1.2%
30	36	1.2%
15	35	1.2%
23	35	1.2%
Other values (331)	2582	87.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	25	0.8%
2	15	0.5%
3	20	0.7%
4	19	0.6%
5	33	1.1%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
UNIQUE

Distinct count	2959
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	51.92560756198357
Minimum	2.150588235294117
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.940997956
Q1	13.11688889
median	17.95658654
Q3	24.91514815
95-th percentile	90.48283333
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	11.79825926

Descriptive statistics

Standard deviation	1038.678599
Coefficient of variation (CV)	20.0032055
Kurtosis	2881.050162
Mean	51.92560756
Median Absolute Deviation (MAD)	5.964070815
Skewness	53.35524577
Sum	153647.8728
Variance	1078853.232

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
18.89583333	1	< 0.1%
17.70607143	1	< 0.1%
26.79906433	1	< 0.1%
25.69635417	1	< 0.1%
20.43421053	1	< 0.1%
20.63668675	1	< 0.1%
16.83756098	1	< 0.1%
20.2366242	1	< 0.1%
13.11444444	1	< 0.1%
114.143964	1	< 0.1%
Other values (2949)	2949	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

Distinct count	1258
Unique (%)	42.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	67.52846579627077
Minimum	1.0
Maximum	366.0
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	26
median	48.66666667
Q3	85.70833333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.70833333

Descriptive statistics

Standard deviation	63.56934557
Coefficient of variation (CV)	0.9413710917
Kurtosis	4.875917435
Mean	67.5284658
Median Absolute Deviation (MAD)	26.33333333
Skewness	2.061314407
Sum	199816.7303
Variance	4041.061696

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
14	24	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
11	17	0.6%
46	17	0.6%
42	16	0.5%
28	16	0.5%
Other values (1248)	2769	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15	0.5%
1.5	1	< 0.1%
2	12	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%

returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct count	208
Unique (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	61.20378506252112
Minimum	0.0
Maximum	80995.0
Zeros	1481
Zeros (%)	50.1%
Memory size	23.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	96.2
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1514.769178
Coefficient of variation (CV)	24.74959966
Kurtosis	2758.400827
Mean	61.20378506
Median Absolute Deviation (MAD)	0
Skewness	51.74099745
Sum	181102
Variance	2294525.662

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1481	50.1%
1	164	5.5%
2	147	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	50	1.7%
7	43	1.5%
8	43	1.5%
Other values (198)	698	23.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1481	50.1%
1	164	5.5%
2	147	5.0%
3	105	3.5%
4	89	3.0%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%

frequency
Real number (ℝ_≥0)

Distinct count	1349
Unique (%)	45.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.06236414246599363
Minimum	0.005449591280653951
Maximum	3.0
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.009428066038
Q1	0.01775413712
median	0.02919708029
Q3	0.05476952305
95-th percentile	0.2068698161
Maximum	3
Range	2.994550409
Interquartile range (IQR)	0.03701538593

Descriptive statistics

Standard deviation	0.1327145366
Coefficient of variation (CV)	2.12805839
Kurtosis	127.9863959
Mean	0.06236414247
Median Absolute Deviation (MAD)	0.01427170716
Skewness	9.012573411
Sum	184.5354976
Variance	0.01761314823

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.1666666667	21	0.7%
0.02777777778	20	0.7%
0.3333333333	20	0.7%
0.09090909091	18	0.6%
0.0625	17	0.6%
0.4	16	0.5%
0.02380952381	15	0.5%
0.1333333333	15	0.5%
0.25	15	0.5%
0.03571428571	15	0.5%
Other values (1339)	2787	94.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%

Value	Count	Frequency (%)
3	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	13	0.4%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct count	1975
Unique (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	249.50441557068999
Minimum	1.0
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	1
5-th percentile	44.47222222
Q1	103.3333333
median	172.3333333
Q3	281.5961538
95-th percentile	598.92
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.2628205

Descriptive statistics

Standard deviation	792.5028622
Coefficient of variation (CV)	3.176307964
Kurtosis	2252.43763
Mean	249.5044156
Median Absolute Deviation (MAD)	82.66666667
Skewness	44.66349716
Sum	738283.5657
Variance	628060.7867

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	9	0.3%
86	9	0.3%
73	9	0.3%
136	8	0.3%
60	8	0.3%
75	8	0.3%
288	7	0.2%
105	7	0.2%
Other values (1965)	2873	97.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2	0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%

unq_basket_size
Real number (ℝ_≥0)

Distinct count	1004
Unique (%)	33.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.169087074215728
Minimum	1.0
Maximum	299.70588235294116
Zeros	0
Zeros (%)	0.0%
Memory size	23.1 KiB

Quantile statistics

Minimum	1
5-th percentile	3.497368421
Q1	10.04166667
median	17.25
Q3	27.75
95-th percentile	56.865
Maximum	299.7058824
Range	298.7058824
Interquartile range (IQR)	17.70833333

Descriptive statistics

Standard deviation	19.4753378
Coefficient of variation (CV)	0.878490744
Kurtosis	27.939353
Mean	22.16908707
Median Absolute Deviation (MAD)	8.25
Skewness	3.508087524
Sum	65598.32865
Variance	379.2887824

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
13	53	1.8%
14	39	1.3%
11	36	1.2%
9	33	1.1%
20	33	1.1%
1	32	1.1%
17	31	1.0%
18	30	1.0%
10	29	1.0%
5	29	1.0%
Other values (994)	2614	88.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	32	1.1%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	df_index	customer_id	gross_revenue	recency_days	number_of_purchases	total_quantity	product_variety	avg_ticket	avg_recency_days	returns	frequency	avg_basket_size	unq_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	21.0	18.152222	35.500000	40.0	0.486111	50.970588	8.735294
1	1	13047	3232.59	56.0	9.0	1390.0	105.0	18.904035	27.250000	35.0	0.048780	154.444444	19.000000
2	2	12583	6705.38	2.0	15.0	5028.0	114.0	28.902500	23.187500	50.0	0.045699	335.200000	15.466667
3	3	13748	948.25	95.0	5.0	439.0	24.0	33.866071	92.666667	0.0	0.017921	87.800000	5.600000
4	4	15100	876.00	333.0	3.0	80.0	1.0	292.000000	8.600000	22.0	0.136364	26.666667	1.000000
5	5	15291	4623.30	25.0	14.0	2102.0	61.0	45.326471	23.200000	29.0	0.054441	150.142857	7.285714
6	6	14688	5630.87	7.0	21.0	3621.0	148.0	17.219786	18.300000	399.0	0.073569	172.428571	15.571429
7	7	17809	5411.91	16.0	12.0	2057.0	46.0	88.719836	35.700000	41.0	0.039106	171.416667	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	567.0	25.543464	4.144444	474.0	0.315508	419.714286	26.142857
9	9	16098	2005.63	87.0	7.0	613.0	34.0	29.934776	47.666667	0.0	0.024390	87.571429	9.571429

Last rows

	df_index	customer_id	gross_revenue	recency_days	number_of_purchases	total_quantity	product_variety	avg_ticket	avg_recency_days	returns	frequency	avg_basket_size	unq_basket_size
2949	5610	17254	272.44	4.0	2.0	252.0	100.0	2.432500	11.0	0.0	0.166667	126.000000	56.0
2950	5616	17727	1060.25	15.0	1.0	645.0	66.0	16.064394	6.0	6.0	0.285714	645.000000	66.0
2951	5626	17232	421.52	2.0	2.0	203.0	30.0	11.708889	12.0	0.0	0.153846	101.500000	18.0
2952	5627	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.0	0.400000	58.000000	2.5
2953	5638	13596	697.04	5.0	2.0	406.0	133.0	4.199036	7.0	0.0	0.250000	203.000000	83.0
2954	5644	14893	1237.85	9.0	2.0	799.0	72.0	16.956849	2.0	0.0	0.666667	399.500000	36.5
2955	5648	12479	473.20	11.0	1.0	382.0	30.0	15.773333	4.0	34.0	0.333333	382.000000	30.0
2956	5669	14126	706.13	7.0	3.0	508.0	14.0	47.075333	3.0	50.0	1.000000	169.333333	5.0
2957	5675	13521	1092.39	1.0	3.0	733.0	312.0	2.511241	4.5	0.0	0.300000	244.333333	145.0
2958	5685	15060	301.84	8.0	4.0	262.0	80.0	2.515333	1.0	0.0	2.000000	65.500000	30.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows